﻿
DELETE FROM CHO_HOLIDAY_CALENDAR;
DELETE FROM CHO_HOLIDAY_CALENDAR_DATES;
DELETE FROM CHO_POLICY;
DELETE FROM CHO_ROLES;
DELETE FROM CHO_ROLE_POLICY;
DELETE FROM CHO_SCHEDULE_TYPES;
DELETE FROM CHO_TASKS;
DELETE FROM CHO_TASK_BATCH;
DELETE FROM CHO_TASK_GRPS;
DELETE FROM CHO_TASK_SCHEDULES;
DELETE FROM CHO_TASK_STATUS;
DELETE FROM CHO_USERS;
DELETE FROM CHO_USER_ROLES;

DELETE FROM CHO_HOLIDAY_CALENDAR_AUDIT;
DELETE FROM CHO_HOLIDAY_CALENDAR_DATES_AUDIT;
DELETE FROM CHO_TASKS_AUDIT;
DELETE FROM CHO_TASK_BATCH_AUDIT;
DELETE FROM CHO_TASK_GRPS_AUDIT;
DELETE FROM CHO_TASK_SCHEDULES_AUDIT;


INSERT INTO CHO_ROLES VALUES (1, 'ADMIN', 'Administrators', 1);

INSERT INTO CHO_POLICY VALUES (1, 'Read Only');
INSERT INTO CHO_POLICY VALUES (2, 'Add Task');
INSERT INTO CHO_POLICY VALUES (3, 'Remove Task');
INSERT INTO CHO_POLICY VALUES (4, 'Edit Task');
INSERT INTO CHO_POLICY VALUES (5, 'Copy Task');
INSERT INTO CHO_POLICY VALUES (6, 'Paste Task');
INSERT INTO CHO_POLICY VALUES (7, 'Move Task');
INSERT INTO CHO_POLICY VALUES (8, 'Export Tasks');
INSERT INTO CHO_POLICY VALUES (9, 'Import Tasks');
INSERT INTO CHO_POLICY VALUES (10, 'Start Task');
INSERT INTO CHO_POLICY VALUES (11, 'Resume Task');
INSERT INTO CHO_POLICY VALUES (12, 'Stop Task');
INSERT INTO CHO_POLICY VALUES (13, 'Abort Task');
INSERT INTO CHO_POLICY VALUES (14, 'Activate Task');
INSERT INTO CHO_POLICY VALUES (15, 'Deactivate Task');
INSERT INTO CHO_POLICY VALUES (16, 'Edit Holiday Calendar');
INSERT INTO CHO_POLICY VALUES (17, 'Manager Users');


INSERT INTO CHO_ROLE_POLICY VALUES (1, 2);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 3);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 4);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 5);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 6);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 7);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 8);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 9);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 10);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 11);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 12);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 13);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 14);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 15);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 16);
INSERT INTO CHO_ROLE_POLICY VALUES (1, 17);

INSERT INTO CHO_SCHEDULE_TYPES VALUES (1, 'DAILY');
INSERT INTO CHO_SCHEDULE_TYPES VALUES (2, 'WEEKLY');
INSERT INTO CHO_SCHEDULE_TYPES VALUES (3, 'MONTHLY');
INSERT INTO CHO_SCHEDULE_TYPES VALUES (4, 'ONCE');

INSERT INTO CHO_TASK_STATUS VALUES (0, 'INVALID');
INSERT INTO CHO_TASK_STATUS VALUES (1, 'INACTIVE');
INSERT INTO CHO_TASK_STATUS VALUES (2, 'ACTIVE');
INSERT INTO CHO_TASK_STATUS VALUES (3, 'RUNNING');
INSERT INTO CHO_TASK_STATUS VALUES (4, 'SUCCESS');
INSERT INTO CHO_TASK_STATUS VALUES (5, 'FAILED');
INSERT INTO CHO_TASK_STATUS VALUES (6, 'STOPPED');
INSERT INTO CHO_TASK_STATUS VALUES (7, 'ABORTED');
INSERT INTO CHO_TASK_STATUS VALUES (8, 'TIMEDOUT');
INSERT INTO CHO_TASK_STATUS VALUES (9, 'SCHEDULED');
INSERT INTO CHO_TASK_STATUS VALUES (10, 'CLEAN');


INSERT INTO CHO_USERS VALUES (1, 'SA', 'Super User', '', 1);
INSERT INTO CHO_USER_ROLES VALUES (1, 1);